Overview: Replace Partial Strings

This operation enables you to find and replace string values within a field. It can be a partial or full replacement of the string, depending on the configuration of the "find" criteria. It is also possible to remove the string completely. This operation is particularly helpful when finding quality values such as "BAD" quality which can all then be removed.

Properties

Category:	Modify
Performance risk:	Low performance risk
Knowledge required:	None

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	No
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	No
Does it modify the current dataset in any way?	Yes

Requirements

A dataset that contains at least one string field.

Results

A modified dataset with the string replaced with the user’s value.
A modified dataset with a string removed. When a string is removed, the entire row is deleted out of the dataset. If you had a dataset with a 100 rows and you opted to remove a certain string which occurs 3 times in the dataset, whether in the same field or not, the modified dataset will contain only 97 rows.